DiscoverDBA Genesis Audio ExperienceHow Does AUTO_SAMPLE_SIZE work? | #dailyDBA 39
How Does AUTO_SAMPLE_SIZE work? | #dailyDBA 39

How Does AUTO_SAMPLE_SIZE work? | #dailyDBA 39

Update: 2020-06-12
Share

Description

0:01 #dbaChallenge: One table had more number of indexes that columns?


-


Questions Picked-up For This Episode:


============================


What basic stats are gathered when we run DBMS_STATS package?




#dba Challenge!




What sample size should I use?




What types of stats are considered by Optimizer?




I want to consolidate data from multiple production databases into one oracle staging database. How can I achieve it?




How can I restore indexes while restoring dropped table?


--


Bonus Question


How to say NO in an interview?


--


#dailyDBA #dbaGenesis


-


Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;)


-


Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration


Link to all DBA courses: https://dbagenesis.com/courses


Link to real-time projects: https://dbagenesis.com/p/projects


Link to support articles: https://support.dbagenesis.com


-


DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!!




DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course.


-


Facebook: https://www.facebook.com/dbagenesis/


Instagram: https://www.instagram.com/dbagenesis/


Twitter: https://twitter.com/DbaGenesis


Website: https://dbagenesis.com/


Contact us: support@dbagenesis.com


-


Start your DBA Journey Today !!




Become an exclusive DBA Genesis member:


https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join

Comments 
00:00
00:00
x

0.5x

0.8x

1.0x

1.25x

1.5x

2.0x

3.0x

Sleep Timer

Off

End of Episode

5 Minutes

10 Minutes

15 Minutes

30 Minutes

45 Minutes

60 Minutes

120 Minutes

How Does AUTO_SAMPLE_SIZE work? | #dailyDBA 39

How Does AUTO_SAMPLE_SIZE work? | #dailyDBA 39

Arun Kumar